{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":1,"defined_names":1,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":42,"n_cols":11,"rows_kept":42}
["Photoscreen Validation Grid"]
["Alaska Blind Child Discovery"]
[null,"Tool:",{"$nulls":4},"Exam criteria:"]
[null,"refer criteria:",{"$nulls":4},"population:"]
[null,"3x3 contingency table:","reference example",{"$nulls":4},"enter real data HERE"]
[null,"2x2 contingency table","Exam +","Exam -","LOST",null,null,"Exam +","Exam -","LOST"]
[null,"sc +","A","B","G",null,"sc +",50,10,1]
[null,"sc -","C","D","H",null,"sc -",149,767,10]
[null,"sc i","E","F","I",null,"sc i",1,11,1]
[{"$nulls":3},"t",null,"z",null,null,{"$f":"H7+H8+H9+I7+I8+I9","v":988},{"$f":"J7+J8+J9","v":12},{"$f":"H7+I7+J7+H8+I8+J8+H9+I9+J9","v":1000}]
["cell"]
["A","TRUE Positive",{"$f":"H7","v":50}]
["B","FALSE positive",{"$f":"I7","v":10},"type 1 error"]
["C","FALSE negative",{"$f":"H8","v":149},"type II error"]
["D","TRUE negative",{"$f":"I8","v":767}]
["E","TRUE inconclusive",{"$f":"H9","v":1}]
["F","FALSE inconclusive",{"$f":"I9","v":11}]
["G","LOST positive",{"$f":"J7","v":1}]
["H","LOST negative",{"$f":"J8","v":10}]
["I","LOST inconclusive",{"$f":"J9","v":1}]
["n","total 2x2",{"$f":"H7+I7+H8+I8","v":976},null,"A+B+C+D"]
["t","not LOST",{"$f":"I10","v":988}]
["z","all screened",{"$f":"K10","v":1000}]
[]
[null,"Sensitivity",{"$f":"C12/(C12+C14)","v":{"v":0.25125628140703515,"d":"25.1%"}},null,"A/(A+C)"]
[null,"Specificity",{"$f":"C15/(C13+C15)","v":{"v":0.9871299871299871,"d":"98.7%"}},null,"D/(B+D)"]
[null,"PPV (precision)",{"$f":"C12/(C12+C13)","v":{"v":0.8333333333333334,"d":"83.3%"}},null,"A/(A+B)"]
[null,"NPV",{"$f":"C15/(C14+C15)","v":{"v":0.8373362445414847,"d":"83.7%"}},null,"D/(C+D)"]
[null,"ABCD sens",{"$f":"C12/(C12+C14+C16+C17)","v":{"v":0.23696682464454977,"d":"23.7%"}},null,"A/(A+E+E+F)"]
[null,"ABCD spec",{"$f":"C15/(C13+C15+C16+C17)","v":{"v":0.9721166032953105,"d":"97.2%"}},null,"D/(B+D+E+F)"]
[null,"irSens",{"$f":"(C12+C16)/(C12+C14+C16)","v":{"v":0.255,"d":"25.5%"}},null,"(A+E)/(A+C+E)"]
[null,"irSpec",{"$f":"C15/(C13+C15+C17)","v":{"v":0.9733502538071066,"d":"97.3%"}},null,"D/(B+D+F)"]
[null,"refer rate",{"$f":"(C12+C13+C18)/C23","v":{"v":0.061,"d":"6%"}},null,"(A+B+G)/t"]
[null,"Prescreen Prev",{"$f":"(C12+C14+C16)/(C12+C13+C14+C15+C16+C17)","v":{"v":0.20242914979757085,"d":"20%"}},null,"(A+C+E)/t"]
[null,"Accuracy",{"$f":"(C12+C15)/(C12+C13+C14+C15)","v":{"v":0.8370901639344263,"d":"84%"}},null,"(A+D)/(A+B+C+D)"]
[null,"inconclusive rate",{"$f":"(C16+C17+C20)/C23","v":{"v":0.013,"d":"1.3%"}},null,"(E+F+I)/z"]
[null,"lost to follow-up",{"$f":"(C18+C19+C20)/C23","v":{"v":0.012,"d":"1.2%"}},null,"(G+H+I)/z"]
[null,"False Pos rate (alpha)",{"$f":"1-C26","v":{"v":0.012870012870012881,"d":"1.3%"}}]
[null,"False negative rate (beta)",{"$f":"1-C25","v":{"v":0.7487437185929648,"d":"74.9%"}}]
[null,"Likelihood ratio positive",{"$f":"C25/(1-C26)","v":{"v":19.522613065326613,"d":"19.5"}}]
[null,"Likelihood ratio negative",{"$f":"C39/C26","v":{"v":0.7585056966711,"d":"0.8"}},{"$nulls":4},"ABCD 9/20/2014"]
[null,"Diagnostic Odds Ratio",{"$f":"C40/C41","v":{"v":25.738255033557017,"d":"25.7"}}]